﻿/*
 *  ChgDoc CMS - GNU General Public License, version 3 (GPL-3.0)
 *  Copyright (C)  2012. Ian Quigley
 *  
 *  This program is free software: you can redistribute it and/or modify
 *  it under the terms of the GNU General Public License as published by
 *  the Free Software Foundation, either version 3 of the License, or
 *  (at your option) any later version.
 *  
 *  This program is distributed in the hope that it will be useful,
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *  GNU General Public License for more details.
 */

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using SqliteORM;

namespace ChgDoc.Entity
{
	[Table]
	public class Settings : TableBase<Settings>
	{
		[PrimaryKey]
		public string Name { get; set; }

		[Field]
		public string Value { get; set; }

		public static Settings Read(string name)
		{
			return Get( ad => ad.Select().Where( t=> t.Name == name ).FirstOrDefault() );
		}

		public static string GetValue( string name )
		{
			var setting = Get( ad => ad.Select().Where( t=> t.Name == name ).FirstOrDefault() );
			if (setting == null)
				return null;

			return setting.Value;
		}

		public static void SetValue( string name, string value )
		{
			Do( ad => ad.CreateUpdate( name, value ) );
		}

		public static IEnumerable<Settings> ReadAll( )
		{
			return Get( ad => ad.Select().ToList() );
		}

		public static void Delete(string name)
		{
			Do( ad => ad.Delete( name ) );
		}
	}
}
